CNSI interview questions 

1.procedure and function diff
2.pacakge disadvantage 
3.triggers disadvantage 
4.hints and types explain one by one 
5. Sub query all types
6.collection methods 
7.collection types
8.bull collect 
9.performance tuning full explain and some questions ask
10. Exception handling 
11.number type we insert varchar what type error come
12.cursor and refcursor why we go refcursor 
13.pipeline 
14.hints type your used project 
15.project details
16.what type of dictionary table your ur project list out some

CNSI Interview Question
what is view
view stored in memory
what is procedure
performance tuning
explain plan structure
can we write insert in view?
hierarchical structure?
consider a table Employe
emp id.     dept id
1                 10
2                    20
3                   10
4                  20
5                   30
a)display the department id 30 using join
b) if we have another table 
department
dept id
10
20
30
10
10
50
60
how to get employee details for department id 50 & 60
 what is function? did we use select statement n functions?
did u have work experience n functions?
if we want to insert data in view possible?

CNSI Interview Question
1) tell me about your self?
2) what is xml tell me berife?
3)tell me about Explain plan?
4)what situation we can use explain plan?
5)explain outer join and write a query scerio?
6)tell me about sequence and sequence query scerio?
7) difference between function and procedures?
8) in your project which situation can used reffcursor?
9) explain reffcursor?
10) what dynamic sql and DBMS_PROFILER?
11) basic Unix commands?
12) what is case and decode?
13) explain mertilized view?
14) tell about index?
15) explain types of indexes?
16)difference between Bree and Bit map index ?
17) in what situation u can use Btree and Bit map? In table?
18) last work request?
19) r u in working developement and production?
20) last issue in your project